<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%@include file="DBHelper.jsp" %>
<%!
public String GetSealList()
{
    String s_List = "";
    String strSelectCmd = "select * from eWebOffice_T_Seal order by D_ID desc";
    Connection con = null;
    ResultSet rs = null;
    try{
        con = getConn();
        rs = ExecuteQuery(con,strSelectCmd);
        while (rs.next())
        {
            
            s_List += "<tr align=center>";
            s_List += "<td>" + rs.getString("D_ID") + "</td>";
            s_List += "<td>" + rs.getString("D_UserName") + "</td>";
            s_List += "<td>" + rs.getString("D_SealName") + "</td>";
            s_List += "<td>" + rs.getString("D_FileType") + "</td>";
            s_List += "<td>";
            s_List += "<a href='seal_edit.jsp?id=" + rs.getString("D_ID") + "'>修改</a>&nbsp;";
            s_List += "<a href='seal_delete.jsp?id=" + rs.getString("D_ID") + "'>删除</a>";
            s_List += "</td>";
            s_List += "</tr>";
        }
        if (s_List.equals(""))
        {
            s_List = "<tr><td colspan=5>没有数据！</td></tr>";
        }
    }catch(Exception e){
        s_List = "<tr><td colspan=5>没有数据！</td></tr>";
    }finally{
        
        closeAll(con,null,rs);
    }
    return (s_List);
}
%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>签章管理</title>
<link rel="Stylesheet" type="text/css" href="css/eweboffice.css" />

</head>
<body>
<div id="bdy">

<table border=0 width="100%">
<tr>
    <td>
        <input type="button" class="btn" value="增加签章" onclick="location.href='seal_edit.jsp'">
    </td>
</tr>
</table>

<br />

<table class="lst">
<tr>
    <th>编号</th>
    <th>用户名称</th>
    <th>签章名称</th>
    <th>签章类型</th>
    <th>操作</th>
</tr>
<%=GetSealList()%>
</table>

</div>
</body>
</html>